Kara Lumley
Kara Lumley
Reactions
-
Re: Formula for Duplicates
Hi Alison, This might give you a start: Used for counting UNIQUE/DISTINCT values only by putting a 1 on first instance of a row value. Great for finding duplicates too. Example: If [Project Name] has…1 · -
Announcing Several Formula Enhancements Available Now
Hi Community, One of my favorite things about Smartsheet is our powerful formula engine. We’ve been hard at work making several improvements that will not only make building formulas easier and faste…2 · -
Re: Critical Path Flag
@Sebastian Mc Thank you for the submission! Right now, we do not have a formula for this - but we are looking into it. Best, Kara2 · -
Re: Report on Previous Entries
Hello, You can see cell changes via the Activity Log, but it may be more helpful to get the cell history changes via the API - that way you can compare data at a large scale. https://smartsheet-platf…1 · -
Re: Parent Relation on Progress %
Hi Laurenz, Great question. What I had to do to get this to work is create another column to extrapolate the percentages - here is the formula to do that: =IF(Status2 = "Empty", 0, IF(Statu…1 ·
